Open File

[Guest Guest_Phillip]

I have a database that needs to be appended while a caller is on the phone with voice guide.

 

Once in a while the database does not get updated because the DB is already in use.

 

This is probably because we have 4 lines and quite a bit of activity.

 

I created a loop for a failed DB append that plays a half second blank wave then goes back to and tries to access the DB again. Then loops again if append is failed.

 

Is this the correct way to handle this? I realize its kind of a hack.

 

ERROR 5.2.3053 OpenDatabase [3045:Could not use 'c:\any.mdb'; file already in use.]

 

Thanks.

[SupportTeam]

Is any other process other then VoiceGuide trying to open this database at the same time?

 

VoiceGuide always opens the MSAccess databases in non-exclusive mode, hence this error should not happen if only VoiceGuide is using the Database.

 

We have never seen it happen in our testing and nobody else has raised this as an issue before.

 

If another process opens the database in exclusive mode then VG would be prevented from opening the database and you would then see the error that you are seeing...

[Guest Guest_Phillip]

Good point. I have a web site that allows people to get the CID and other information entered by a caller using the same DB. Sometimes I may be doing queries or reports on the database too.